prepare("select * from stock_prices where item_name = '$names'") ; $chk->execute(); if($chk->rowcount() > 0) { $msg = $names ."-This Item price has been Fixed before. " ; } else { if($user->regprice($cat,$names,$price,$adm)) { $msg = $names.'-'."Price Fixed" ; } } } ?> Admin Panel

Dashboard

FIXING PRICES

prepare("select * from stock_prices") ; $gtcat->execute() ; $count = 0 ; while($row = $gtcat->fetch(pdo::FETCH_ASSOC)) { $count++ ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; ?> " ; } ?>
SN CATEGORY NAME ITEM NAME ITEM PRICE ACTIONS
".$count."".$row['item_category']."".$row['item_name']."".$row['prices']."EDIT PRICE